{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 周边搜索\n",
    "* url\n",
    "> https://restapi.amap.com/v5/place/text?parameters\n",
    "* 请求参数（两类）\n",
    "> 1. 按照关键词搜索\n",
    "> 2. 按照查询POI类型（分类表-下载）"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 按照关键词搜索"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "geo_url = \"https://restapi.amap.com/v3/geocode/geo?parameters\"\n",
    "\n",
    "# 3. 请求方法：get\n",
    "\n",
    "# 4.请求参数\n",
    "payload = {\n",
    "    \"key\":\"1d943530c915e70ad13e7bed4acec0d3\",\n",
    "    \"address\":\"广东省广州市从化区南方学院\"\n",
    "}\n",
    "\n",
    "# 5.发起请求 \n",
    "r = requests.get(url=geo_url, params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'count': '1',\n",
       " 'geocodes': [{'formatted_address': '广东省广州市从化区温泉镇中心大学南方学院',\n",
       "   'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'citycode': '020',\n",
       "   'city': '广州市',\n",
       "   'district': '从化区',\n",
       "   'township': [],\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'adcode': '440117',\n",
       "   'street': [],\n",
       "   'number': [],\n",
       "   'location': '113.678280,23.628439',\n",
       "   'level': '兴趣点'}]}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'113.678280,23.628439'"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "广州南方学院_location = r.json()['geocodes'][0]['location']\n",
    "广州南方学院_location"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "around_url = 'https://restapi.amap.com/v3/place/around?parameters'\n",
    "\n",
    "payload = {\n",
    "    \"key\":\"1d943530c915e70ad13e7bed4acec0d3\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"keywords\":\"餐厅\"\n",
    "    'page':2 #默认值为1\n",
    "}\n",
    "r = requests.get(around_url,params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'suggestion': {'keywords': [], 'cities': []},\n",
       " 'count': '287',\n",
       " 'infocode': '10000',\n",
       " 'pois': [{'parent': [],\n",
       "   'address': '温泉中大南方学院',\n",
       "   'distance': '359',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '淮南牛肉粉丝汤',\n",
       "   'location': '113.676568,23.631259',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCKTON'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中大南方学院',\n",
       "   'distance': '359',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '食再添(中大店)',\n",
       "   'location': '113.676568,23.631259',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCK40Y'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中大南方学院',\n",
       "   'distance': '359',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '深海一只鱼(中大店)',\n",
       "   'location': '113.676568,23.631259',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HRO7KVZA'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中大南方',\n",
       "   'distance': '359',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '莹香美食',\n",
       "   'location': '113.676568,23.631259',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H1MR1AGD'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中大南方',\n",
       "   'distance': '359',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '麻辣香锅木桶饭',\n",
       "   'location': '113.676568,23.631259',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0G2GMNM5K'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中大南方学院',\n",
       "   'distance': '359',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '0.6',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '鱼诱(中大店)',\n",
       "   'location': '113.676568,23.631259',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFL7MCT2'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇温泉乌土村随便公寓',\n",
       "   'distance': '367',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;外国餐厅;韩国料理',\n",
       "   'photos': [],\n",
       "   'typecode': '050203',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '鸡啤咯哒(中大店)',\n",
       "   'location': '113.680035,23.631318',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCMJ59'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中山大学南方学院综合楼',\n",
       "   'distance': '388',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '王牌烤肉拌饭',\n",
       "   'location': '113.680126,23.631492',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H1M7YDQH'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中山大学南方学院博学路6号西区食堂首层',\n",
       "   'distance': '395',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '26.00',\n",
       "    'opentime2': '07:00-23:00',\n",
       "    'rating': '4.2',\n",
       "    'open_time': '07:00-23:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;快餐厅;快餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/eb67d674d85e0d3ab093b5073c0c6a65'}],\n",
       "   'typecode': '050300',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '肯德基(从化南方学院店)',\n",
       "   'location': '113.676231,23.631452',\n",
       "   'tel': '4009200715',\n",
       "   'shopid': [],\n",
       "   'id': 'B0H1YMW8PH'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇笃行路20、22、24号中山大学南方学院商业中心三楼3F-031',\n",
       "   'distance': '408',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '猪杂汤饭',\n",
       "   'location': '113.676500,23.631722',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0G3FCLIZ4'},\n",
       "  {'parent': [],\n",
       "   'address': '博学路与中山路交叉口南360米',\n",
       "   'distance': '432',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '大可鱼酸菜鱼米饭',\n",
       "   'location': '113.675820,23.631603',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0G3F5KULC'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇广州南方学院博学路6号',\n",
       "   'distance': '450',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': '每天06:30-22:00',\n",
       "    'rating': '4.4',\n",
       "    'open_time': '06:30-22:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/2c37d66c4839faf438a9a382d3ec507f'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '广州南方学院第一食堂',\n",
       "   'location': '113.676084,23.632024',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFIXV3OZ'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇笃行路20、22、24号中山大学南方学院商业中心三楼3F-031',\n",
       "   'distance': '450',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '2.2',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050118',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '精品沙县(中大店)',\n",
       "   'location': '113.676059,23.631942',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0G3AOJXUX'},\n",
       "  {'parent': [],\n",
       "   'address': '博学路4附近',\n",
       "   'distance': '466',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.6',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '广州南方学院西区饭堂',\n",
       "   'location': '113.676210,23.632177',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HGD57SV2'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇广州南方学院后门润泰超市1层05号商铺',\n",
       "   'distance': '471',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '湘味小厨',\n",
       "   'location': '113.679283,23.632572',\n",
       "   'tel': '13005184390',\n",
       "   'shopid': [],\n",
       "   'id': 'B0GKHC2KQN'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇广州南方学院后门润泰超市1层05号商铺',\n",
       "   'distance': '471',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '东记乡村美食',\n",
       "   'location': '113.679283,23.632572',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0G3APADKJ'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉区广州南方学院',\n",
       "   'distance': '480',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;外国餐厅;西餐厅(综合风味)',\n",
       "   'photos': [],\n",
       "   'typecode': '050201',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': 'Uni-hotel西餐',\n",
       "   'location': '113.679222,23.632671',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0GR3OMDZ2'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇广州南方学院后门润泰超市1层05号商铺',\n",
       "   'distance': '485',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;外国餐厅;外国餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050200',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '铁板烧',\n",
       "   'location': '113.679405,23.632673',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H6ZUSDBT'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇广州南方学院后门润泰超市1层05号商铺',\n",
       "   'distance': '485',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '老地方乐山油炸串串',\n",
       "   'location': '113.679405,23.632673',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H6Y1AW1Y'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇广州南方学院后门润泰超市1层05号商铺',\n",
       "   'distance': '485',\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050118',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '港渝好粥道',\n",
       "   'location': '113.679405,23.632673',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H64DILIJ'}],\n",
       " 'status': '1',\n",
       " 'info': 'OK'}"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>parent</th>\n",
       "      <th>address</th>\n",
       "      <th>distance</th>\n",
       "      <th>pname</th>\n",
       "      <th>importance</th>\n",
       "      <th>biz_type</th>\n",
       "      <th>cityname</th>\n",
       "      <th>type</th>\n",
       "      <th>photos</th>\n",
       "      <th>typecode</th>\n",
       "      <th>...</th>\n",
       "      <th>name</th>\n",
       "      <th>location</th>\n",
       "      <th>tel</th>\n",
       "      <th>shopid</th>\n",
       "      <th>id</th>\n",
       "      <th>biz_ext.cost</th>\n",
       "      <th>biz_ext.opentime2</th>\n",
       "      <th>biz_ext.rating</th>\n",
       "      <th>biz_ext.open_time</th>\n",
       "      <th>biz_ext.meal_ordering</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉中大南方学院</td>\n",
       "      <td>359</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>淮南牛肉粉丝汤</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCKTON</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中大南方学院</td>\n",
       "      <td>359</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>食再添(中大店)</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCK40Y</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中大南方学院</td>\n",
       "      <td>359</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>深海一只鱼(中大店)</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HRO7KVZA</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中大南方</td>\n",
       "      <td>359</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>莹香美食</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H1MR1AGD</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中大南方</td>\n",
       "      <td>359</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>麻辣香锅木桶饭</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0G2GMNM5K</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中大南方学院</td>\n",
       "      <td>359</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>鱼诱(中大店)</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFL7MCT2</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0.6</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇温泉乌土村随便公寓</td>\n",
       "      <td>367</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;外国餐厅;韩国料理</td>\n",
       "      <td>[]</td>\n",
       "      <td>050203</td>\n",
       "      <td>...</td>\n",
       "      <td>鸡啤咯哒(中大店)</td>\n",
       "      <td>113.680035,23.631318</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCMJ59</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中山大学南方学院综合楼</td>\n",
       "      <td>388</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>王牌烤肉拌饭</td>\n",
       "      <td>113.680126,23.631492</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H1M7YDQH</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中山大学南方学院博学路6号西区食堂首层</td>\n",
       "      <td>395</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;快餐厅;快餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050300</td>\n",
       "      <td>...</td>\n",
       "      <td>肯德基(从化南方学院店)</td>\n",
       "      <td>113.676231,23.631452</td>\n",
       "      <td>4009200715</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H1YMW8PH</td>\n",
       "      <td>26.00</td>\n",
       "      <td>07:00-23:00</td>\n",
       "      <td>4.2</td>\n",
       "      <td>07:00-23:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇笃行路20、22、24号中山大学南方学院商业中心三楼3F-031</td>\n",
       "      <td>408</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>猪杂汤饭</td>\n",
       "      <td>113.676500,23.631722</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0G3FCLIZ4</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>[]</td>\n",
       "      <td>博学路与中山路交叉口南360米</td>\n",
       "      <td>432</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>大可鱼酸菜鱼米饭</td>\n",
       "      <td>113.675820,23.631603</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0G3F5KULC</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇广州南方学院博学路6号</td>\n",
       "      <td>450</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>广州南方学院第一食堂</td>\n",
       "      <td>113.676084,23.632024</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFIXV3OZ</td>\n",
       "      <td>[]</td>\n",
       "      <td>每天06:30-22:00</td>\n",
       "      <td>4.4</td>\n",
       "      <td>06:30-22:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇笃行路20、22、24号中山大学南方学院商业中心三楼3F-031</td>\n",
       "      <td>450</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>精品沙县(中大店)</td>\n",
       "      <td>113.676059,23.631942</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0G3AOJXUX</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2.2</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>[]</td>\n",
       "      <td>博学路4附近</td>\n",
       "      <td>466</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>广州南方学院西区饭堂</td>\n",
       "      <td>113.676210,23.632177</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HGD57SV2</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.6</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇广州南方学院后门润泰超市1层05号商铺</td>\n",
       "      <td>471</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>湘味小厨</td>\n",
       "      <td>113.679283,23.632572</td>\n",
       "      <td>13005184390</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0GKHC2KQN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇广州南方学院后门润泰超市1层05号商铺</td>\n",
       "      <td>471</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>东记乡村美食</td>\n",
       "      <td>113.679283,23.632572</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0G3APADKJ</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉区广州南方学院</td>\n",
       "      <td>480</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;外国餐厅;西餐厅(综合风味)</td>\n",
       "      <td>[]</td>\n",
       "      <td>050201</td>\n",
       "      <td>...</td>\n",
       "      <td>Uni-hotel西餐</td>\n",
       "      <td>113.679222,23.632671</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0GR3OMDZ2</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇广州南方学院后门润泰超市1层05号商铺</td>\n",
       "      <td>485</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;外国餐厅;外国餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050200</td>\n",
       "      <td>...</td>\n",
       "      <td>铁板烧</td>\n",
       "      <td>113.679405,23.632673</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H6ZUSDBT</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇广州南方学院后门润泰超市1层05号商铺</td>\n",
       "      <td>485</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>老地方乐山油炸串串</td>\n",
       "      <td>113.679405,23.632673</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H6Y1AW1Y</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇广州南方学院后门润泰超市1层05号商铺</td>\n",
       "      <td>485</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>港渝好粥道</td>\n",
       "      <td>113.679405,23.632673</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H64DILIJ</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   parent                              address distance pname importance  \\\n",
       "0      []                             温泉中大南方学院      359   广东省         []   \n",
       "1      []                            温泉镇中大南方学院      359   广东省         []   \n",
       "2      []                            温泉镇中大南方学院      359   广东省         []   \n",
       "3      []                              温泉镇中大南方      359   广东省         []   \n",
       "4      []                              温泉镇中大南方      359   广东省         []   \n",
       "5      []                            温泉镇中大南方学院      359   广东省         []   \n",
       "6      []                         温泉镇温泉乌土村随便公寓      367   广东省         []   \n",
       "7      []                       温泉镇中山大学南方学院综合楼      388   广东省         []   \n",
       "8      []               温泉镇中山大学南方学院博学路6号西区食堂首层      395   广东省         []   \n",
       "9      []  温泉镇笃行路20、22、24号中山大学南方学院商业中心三楼3F-031      408   广东省         []   \n",
       "10     []                      博学路与中山路交叉口南360米      432   广东省         []   \n",
       "11     []                       温泉镇广州南方学院博学路6号      450   广东省         []   \n",
       "12     []  温泉镇笃行路20、22、24号中山大学南方学院商业中心三楼3F-031      450   广东省         []   \n",
       "13     []                               博学路4附近      466   广东省         []   \n",
       "14     []               温泉镇广州南方学院后门润泰超市1层05号商铺      471   广东省         []   \n",
       "15     []               温泉镇广州南方学院后门润泰超市1层05号商铺      471   广东省         []   \n",
       "16     []                            温泉区广州南方学院      480   广东省         []   \n",
       "17     []               温泉镇广州南方学院后门润泰超市1层05号商铺      485   广东省         []   \n",
       "18     []               温泉镇广州南方学院后门润泰超市1层05号商铺      485   广东省         []   \n",
       "19     []               温泉镇广州南方学院后门润泰超市1层05号商铺      485   广东省         []   \n",
       "\n",
       "   biz_type cityname                 type  \\\n",
       "0     diner      广州市         餐饮服务;中餐厅;中餐厅   \n",
       "1     diner      广州市         餐饮服务;中餐厅;中餐厅   \n",
       "2     diner      广州市         餐饮服务;中餐厅;中餐厅   \n",
       "3     diner      广州市         餐饮服务;中餐厅;中餐厅   \n",
       "4     diner      广州市         餐饮服务;中餐厅;中餐厅   \n",
       "5     diner      广州市         餐饮服务;中餐厅;中餐厅   \n",
       "6     diner      广州市       餐饮服务;外国餐厅;韩国料理   \n",
       "7     diner      广州市         餐饮服务;中餐厅;中餐厅   \n",
       "8     diner      广州市         餐饮服务;快餐厅;快餐厅   \n",
       "9     diner      广州市         餐饮服务;中餐厅;中餐厅   \n",
       "10    diner      广州市         餐饮服务;中餐厅;中餐厅   \n",
       "11    diner      广州市         餐饮服务;中餐厅;中餐厅   \n",
       "12    diner      广州市   餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "13    diner      广州市         餐饮服务;中餐厅;中餐厅   \n",
       "14    diner      广州市         餐饮服务;中餐厅;中餐厅   \n",
       "15    diner      广州市         餐饮服务;中餐厅;中餐厅   \n",
       "16    diner      广州市  餐饮服务;外国餐厅;西餐厅(综合风味)   \n",
       "17    diner      广州市       餐饮服务;外国餐厅;外国餐厅   \n",
       "18    diner      广州市         餐饮服务;中餐厅;中餐厅   \n",
       "19    diner      广州市   餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "\n",
       "                                               photos typecode  ...  \\\n",
       "0                                                  []   050100  ...   \n",
       "1                                                  []   050100  ...   \n",
       "2                                                  []   050100  ...   \n",
       "3                                                  []   050100  ...   \n",
       "4                                                  []   050100  ...   \n",
       "5                                                  []   050100  ...   \n",
       "6                                                  []   050203  ...   \n",
       "7                                                  []   050100  ...   \n",
       "8   [{'title': [], 'url': 'http://store.is.autonav...   050300  ...   \n",
       "9                                                  []   050100  ...   \n",
       "10                                                 []   050100  ...   \n",
       "11  [{'title': [], 'url': 'http://store.is.autonav...   050100  ...   \n",
       "12                                                 []   050118  ...   \n",
       "13                                                 []   050100  ...   \n",
       "14                                                 []   050100  ...   \n",
       "15                                                 []   050100  ...   \n",
       "16                                                 []   050201  ...   \n",
       "17                                                 []   050200  ...   \n",
       "18                                                 []   050100  ...   \n",
       "19                                                 []   050118  ...   \n",
       "\n",
       "            name              location          tel shopid          id  \\\n",
       "0        淮南牛肉粉丝汤  113.676568,23.631259           []     []  B0HROCKTON   \n",
       "1       食再添(中大店)  113.676568,23.631259           []     []  B0HROCK40Y   \n",
       "2     深海一只鱼(中大店)  113.676568,23.631259           []     []  B0HRO7KVZA   \n",
       "3           莹香美食  113.676568,23.631259           []     []  B0H1MR1AGD   \n",
       "4        麻辣香锅木桶饭  113.676568,23.631259           []     []  B0G2GMNM5K   \n",
       "5        鱼诱(中大店)  113.676568,23.631259           []     []  B0FFL7MCT2   \n",
       "6      鸡啤咯哒(中大店)  113.680035,23.631318           []     []  B0HROCMJ59   \n",
       "7         王牌烤肉拌饭  113.680126,23.631492           []     []  B0H1M7YDQH   \n",
       "8   肯德基(从化南方学院店)  113.676231,23.631452   4009200715     []  B0H1YMW8PH   \n",
       "9           猪杂汤饭  113.676500,23.631722           []     []  B0G3FCLIZ4   \n",
       "10      大可鱼酸菜鱼米饭  113.675820,23.631603           []     []  B0G3F5KULC   \n",
       "11    广州南方学院第一食堂  113.676084,23.632024           []     []  B0FFIXV3OZ   \n",
       "12     精品沙县(中大店)  113.676059,23.631942           []     []  B0G3AOJXUX   \n",
       "13    广州南方学院西区饭堂  113.676210,23.632177           []     []  B0HGD57SV2   \n",
       "14          湘味小厨  113.679283,23.632572  13005184390     []  B0GKHC2KQN   \n",
       "15        东记乡村美食  113.679283,23.632572           []     []  B0G3APADKJ   \n",
       "16   Uni-hotel西餐  113.679222,23.632671           []     []  B0GR3OMDZ2   \n",
       "17           铁板烧  113.679405,23.632673           []     []  B0H6ZUSDBT   \n",
       "18     老地方乐山油炸串串  113.679405,23.632673           []     []  B0H6Y1AW1Y   \n",
       "19         港渝好粥道  113.679405,23.632673           []     []  B0H64DILIJ   \n",
       "\n",
       "   biz_ext.cost biz_ext.opentime2 biz_ext.rating biz_ext.open_time  \\\n",
       "0            []                []             []                []   \n",
       "1            []                []             []                []   \n",
       "2            []                []             []                []   \n",
       "3            []                []             []                []   \n",
       "4            []                []             []                []   \n",
       "5            []                []            0.6                []   \n",
       "6            []                []             []                []   \n",
       "7            []                []             []                []   \n",
       "8         26.00       07:00-23:00            4.2       07:00-23:00   \n",
       "9            []                []             []                []   \n",
       "10           []                []             []                []   \n",
       "11           []     每天06:30-22:00            4.4       06:30-22:00   \n",
       "12           []                []            2.2                []   \n",
       "13           []                []            3.6                []   \n",
       "14           []                []             []                []   \n",
       "15           []                []             []                []   \n",
       "16           []                []             []                []   \n",
       "17           []                []             []                []   \n",
       "18           []                []             []                []   \n",
       "19           []                []             []                []   \n",
       "\n",
       "   biz_ext.meal_ordering  \n",
       "0                      0  \n",
       "1                      0  \n",
       "2                      0  \n",
       "3                      0  \n",
       "4                      0  \n",
       "5                      0  \n",
       "6                      0  \n",
       "7                      0  \n",
       "8                      0  \n",
       "9                      0  \n",
       "10                     0  \n",
       "11                     0  \n",
       "12                     0  \n",
       "13                     0  \n",
       "14                     0  \n",
       "15                     0  \n",
       "16                     0  \n",
       "17                     0  \n",
       "18                     0  \n",
       "19                     0  \n",
       "\n",
       "[20 rows x 24 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.json_normalize(r.json()['pois'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
